package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class StudentGroupDBTable {
    private static final String SEPARATOR = ".";
    public static final String TABLE_NAME = "StudentsGroup";

    public static final String ID = "students_group_id";
    public static final String TYPE = "students_group_type";
    public static final String FK_YEAR_ID = "students_group_fk_year_id";

    public static final String STUDENTGROUP_ID = TABLE_NAME + SEPARATOR + ID;
    public static final String STUDENTGROUP_TYPE = TABLE_NAME + SEPARATOR + TYPE;
    public static final String STUDENTGROUP_FK_YEAR_ID = TABLE_NAME + SEPARATOR + FK_YEAR_ID;

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        TYPE + " TEXT NOT NULL, " +
                        FK_YEAR_ID + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }

}